Pandas Profiling Report

Dataset statistics

Number of variables	27
Number of observations	112647
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	130.3 MiB
Average record size in memory	1.2 KiB

Variable types

Numeric	9
Categorical	17
DateTime	1

Alerts

`order_id` has a high cardinality: 98665 distinct values	High cardinality
`product_id` has a high cardinality: 32951 distinct values	High cardinality
`seller_id` has a high cardinality: 3095 distinct values	High cardinality
`seller_city` has a high cardinality: 611 distinct values	High cardinality
`product_category_name_english` has a high cardinality: 72 distinct values	High cardinality
`customer_id` has a high cardinality: 98665 distinct values	High cardinality
`order_delivery_date` has a high cardinality: 96049 distinct values	High cardinality
`order_estimated_delivery_date` has a high cardinality: 449 distinct values	High cardinality
`payment_type` has a high cardinality: 74 distinct values	High cardinality
`customer_unique_id` has a high cardinality: 95419 distinct values	High cardinality
`customer_city` has a high cardinality: 4110 distinct values	High cardinality
`order_year` is highly correlated with `order_month`	High correlation
`order_month` is highly correlated with `order_year`	High correlation
`order_year` is highly correlated with `order_month`	High correlation
`order_month` is highly correlated with `order_year`	High correlation
`seller_zip_code` is highly correlated with `seller_state` and 1 other fields	High correlation
`seller_state` is highly correlated with `seller_zip_code` and 1 other fields	High correlation
`product_category_name_english` is highly correlated with `seller_zip_code` and 1 other fields	High correlation
`customer_zip_code` is highly correlated with `customer_state`	High correlation
`customer_state` is highly correlated with `customer_zip_code`	High correlation
`order_year` is highly correlated with `order_month`	High correlation
`order_month` is highly correlated with `order_year`	High correlation
`df_index` is uniformly distributed	Uniform
`order_id` is uniformly distributed	Uniform
`customer_id` is uniformly distributed	Uniform
`order_delivery_date` is uniformly distributed	Uniform
`customer_unique_id` is uniformly distributed	Uniform
`df_index` has unique values	Unique

Reproduction

Analysis started	2021-12-17 18:52:44.305805
Analysis finished	2021-12-17 18:53:30.110107
Duration	45.8 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

UNIFORM
UNIQUE

Distinct	112647
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	56323.75256

Minimum	0
Maximum	112649
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	880.2 KiB

Quantile statistics

Minimum	0
5-th percentile	5632.3
Q1	28161.5
median	56323
Q3	84487.5
95-th percentile	107016.7
Maximum	112649
Range	112649
Interquartile range (IQR)	56326

Descriptive statistics

Standard deviation	32519.50873
Coefficient of variation (CV)	0.5773675804
Kurtosis	-1.199991297
Mean	56323.75256
Median Absolute Deviation (MAD)	28163
Skewness	5.183415282 × 10^-5
Sum	6344701755
Variance	1057518448
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
75094	1	< 0.1%
75105	1	< 0.1%
75104	1	< 0.1%
75103	1	< 0.1%
75102	1	< 0.1%
75101	1	< 0.1%
75100	1	< 0.1%
75099	1	< 0.1%
75098	1	< 0.1%
Other values (112637)	112637	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
112649	1	< 0.1%
112648	1	< 0.1%
112647	1	< 0.1%
112646	1	< 0.1%
112645	1	< 0.1%
112644	1	< 0.1%
112643	1	< 0.1%
112642	1	< 0.1%
112641	1	< 0.1%
112640	1	< 0.1%

order_id
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	98665
Distinct (%)	87.6%
Missing	0
Missing (%)	0.0%
Memory size	9.6 MiB

8272b63d03f5f79c56e9e4120aec44ef	21
ab14fdcfbe524636d65ee38360e22ce8	20
1b15974a0141d54e36626dca3fdc731a	20
9ef13efd6949e4573a18964dd1bbe7f5	15
428a2f660dc84138d969ccd69a0ab6d5	15
Other values (98660)	112556

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	88863 ?
Unique (%)	78.9%

Sample

1st row	00010242fe8c5a6d1ba2dd792cb16214
2nd row	00018f77f2f0320c557190d7a144bdd3
3rd row	000229ec398224ef6ca0657da4fc703e
4th row	00024acbcdf0a6daa1e931b038114c75
5th row	00042b26cf59d7ce69dfabb4e55b4fd9

Common Values

Value	Count	Frequency (%)
8272b63d03f5f79c56e9e4120aec44ef	21	< 0.1%
ab14fdcfbe524636d65ee38360e22ce8	20	< 0.1%
1b15974a0141d54e36626dca3fdc731a	20	< 0.1%
9ef13efd6949e4573a18964dd1bbe7f5	15	< 0.1%
428a2f660dc84138d969ccd69a0ab6d5	15	< 0.1%
73c8ab38f07dc94389065f7eba4f297a	14	< 0.1%
9bdc4d4c71aa1de4606060929dee888c	14	< 0.1%
37ee401157a3a0b28c9c6d0ed8c3b24b	13	< 0.1%
c05d6a79e55da72ca780ce90364abed9	12	< 0.1%
3a213fcdfe7d98be74ea0dc05a8b31ae	12	< 0.1%
Other values (98655)	112491	99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
8272b63d03f5f79c56e9e4120aec44ef	21	< 0.1%
1b15974a0141d54e36626dca3fdc731a	20	< 0.1%
ab14fdcfbe524636d65ee38360e22ce8	20	< 0.1%
9ef13efd6949e4573a18964dd1bbe7f5	15	< 0.1%
428a2f660dc84138d969ccd69a0ab6d5	15	< 0.1%
73c8ab38f07dc94389065f7eba4f297a	14	< 0.1%
9bdc4d4c71aa1de4606060929dee888c	14	< 0.1%
37ee401157a3a0b28c9c6d0ed8c3b24b	13	< 0.1%
2c2a19b5703863c908512d135aa6accc	12	< 0.1%
af822dacd6f5cff7376413c03a388bb7	12	< 0.1%
Other values (98655)	112491	99.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

order_item_id
Real number (ℝ_≥0)

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.197812636

Minimum	1
Maximum	21
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	880.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	21
Range	20
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.7051086788
Coefficient of variation (CV)	0.5886635837
Kurtosis	103.8700387
Mean	1.197812636
Median Absolute Deviation (MAD)	0
Skewness	7.580982582
Sum	134930
Variance	0.497178249
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
1	98665	87.6%
2	9802	8.7%
3	2286	2.0%
4	965	0.9%
5	460	0.4%
6	256	0.2%
7	58	0.1%
8	36	< 0.1%
9	28	< 0.1%
10	25	< 0.1%
Other values (11)	66	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	98665	87.6%
2	9802	8.7%
3	2286	2.0%
4	965	0.9%
5	460	0.4%
6	256	0.2%
7	58	0.1%
8	36	< 0.1%
9	28	< 0.1%
10	25	< 0.1%

Value	Count	Frequency (%)
21	1	< 0.1%
20	3	< 0.1%
19	3	< 0.1%
18	3	< 0.1%
17	3	< 0.1%
16	3	< 0.1%
15	5	< 0.1%
14	7	< 0.1%
13	8	< 0.1%
12	13	< 0.1%

product_id
Categorical

HIGH CARDINALITY

Distinct	32951
Distinct (%)	29.3%
Missing	0
Missing (%)	0.0%
Memory size	9.6 MiB

aca2eb7d00ea1a7b8ebd4e68314663af	527
99a4788cb24856965c36a24e339b6058	488
422879e10f46682990de24d770e7f83d	484
389d119b48cf3043d311335e499d9c6b	392
368c6c730842d78016ad823897a372db	388
Other values (32946)	110368

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	18118 ?
Unique (%)	16.1%

Sample

1st row	4244733e06e7ecb4970a6e2683c13e61
2nd row	e5f2d52b802189ee658865ca93d83a8f
3rd row	c777355d18b72b67abbeef9df44fd0fd
4th row	7634da152a4610f1595efa32f14722fc
5th row	ac6c3623068f30de03045865e4e10089

Common Values

Value	Count	Frequency (%)
aca2eb7d00ea1a7b8ebd4e68314663af	527	0.5%
99a4788cb24856965c36a24e339b6058	488	0.4%
422879e10f46682990de24d770e7f83d	484	0.4%
389d119b48cf3043d311335e499d9c6b	392	0.3%
368c6c730842d78016ad823897a372db	388	0.3%
53759a2ecddad2bb87a079a1f1519f73	373	0.3%
d1c427060a0f73f6b889a5c7c61f2ac4	343	0.3%
53b36df67ebb7c41585e8d54d6772e08	323	0.3%
154e7e31ebfa092203795c972e5804a6	281	0.2%
3dd2a17168ec895c781a9191c1e95ad7	274	0.2%
Other values (32941)	108774	96.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
aca2eb7d00ea1a7b8ebd4e68314663af	527	0.5%
99a4788cb24856965c36a24e339b6058	488	0.4%
422879e10f46682990de24d770e7f83d	484	0.4%
389d119b48cf3043d311335e499d9c6b	392	0.3%
368c6c730842d78016ad823897a372db	388	0.3%
53759a2ecddad2bb87a079a1f1519f73	373	0.3%
d1c427060a0f73f6b889a5c7c61f2ac4	343	0.3%
53b36df67ebb7c41585e8d54d6772e08	323	0.3%
154e7e31ebfa092203795c972e5804a6	281	0.2%
3dd2a17168ec895c781a9191c1e95ad7	274	0.2%
Other values (32941)	108774	96.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

seller_id
Categorical

HIGH CARDINALITY

Distinct	3095
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Memory size	9.6 MiB

6560211a19b47992c3666cc44a7e94c0	2033
4a3ca9315b744ce9f8e9374361493884	1987
1f50f920176fa81dab994f9023523100	1931
cc419e0650a3c5ba77189a1882b7556a	1775
da8622b14eb17ae2831f4ac5b9dab84a	1551
Other values (3090)	103370

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	509 ?
Unique (%)	0.5%

Sample

1st row	48436dade18ac8b2bce089ec2a041202
2nd row	dd7ddc04e1b6c2c614352b383efe2d36
3rd row	5b51032eddd242adc84c38acab88f23d
4th row	9d7a1d34a5052409006425275ba1c2b4
5th row	df560393f3a51e74553ab94004ba5c87

Common Values

Value	Count	Frequency (%)
6560211a19b47992c3666cc44a7e94c0	2033	1.8%
4a3ca9315b744ce9f8e9374361493884	1987	1.8%
1f50f920176fa81dab994f9023523100	1931	1.7%
cc419e0650a3c5ba77189a1882b7556a	1775	1.6%
da8622b14eb17ae2831f4ac5b9dab84a	1551	1.4%
955fee9216a65b617aa5c0531780ce60	1499	1.3%
1025f0e2d44d7041d6cf58b6550e0bfa	1428	1.3%
7c67e1448b00f6e969d365cea6b010ab	1364	1.2%
ea8482cd71df3c1969d7b9473ff13abc	1203	1.1%
7a67c85e85bb2ce8582c35f2203ad736	1171	1.0%
Other values (3085)	96705	85.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
6560211a19b47992c3666cc44a7e94c0	2033	1.8%
4a3ca9315b744ce9f8e9374361493884	1987	1.8%
1f50f920176fa81dab994f9023523100	1931	1.7%
cc419e0650a3c5ba77189a1882b7556a	1775	1.6%
da8622b14eb17ae2831f4ac5b9dab84a	1551	1.4%
955fee9216a65b617aa5c0531780ce60	1499	1.3%
1025f0e2d44d7041d6cf58b6550e0bfa	1428	1.3%
7c67e1448b00f6e969d365cea6b010ab	1364	1.2%
ea8482cd71df3c1969d7b9473ff13abc	1203	1.1%
7a67c85e85bb2ce8582c35f2203ad736	1171	1.0%
Other values (3085)	96705	85.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

seller_zip_code
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	2246
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24437.64254

Minimum	1001
Maximum	99730
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	880.2 KiB

Quantile statistics

Minimum	1001
5-th percentile	2969
Q1	6429
median	13568
Q3	27930
95-th percentile	88330
Maximum	99730
Range	98729
Interquartile range (IQR)	21501

Descriptive statistics

Standard deviation	27594.81009
Coefficient of variation (CV)	1.129192803
Kurtosis	0.9332621576
Mean	24437.64254
Median Absolute Deviation (MAD)	8038
Skewness	1.555585514
Sum	2752827119
Variance	761473543.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14940	7750	6.9%
5849	2047	1.8%
15025	2008	1.8%
9015	1781	1.6%
13405	1567	1.4%
4782	1518	1.3%
8577	1456	1.3%
3204	1428	1.3%
4160	1229	1.1%
13232	1195	1.1%
Other values (2236)	90668	80.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1001	19	< 0.1%
1021	39	< 0.1%
1022	5	< 0.1%
1023	5	< 0.1%
1026	303	0.3%
1031	124	0.1%
1035	17	< 0.1%
1039	1	< 0.1%
1040	24	< 0.1%
1041	2	< 0.1%

Value	Count	Frequency (%)
99730	12	< 0.1%
99700	2	< 0.1%
99670	1	< 0.1%
99500	57	0.1%
99300	2	< 0.1%
98975	21	< 0.1%
98920	2	< 0.1%
98910	13	< 0.1%
98803	62	0.1%
98780	4	< 0.1%

seller_city
Categorical

HIGH CARDINALITY

Distinct	611
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	7.2 MiB

sao paulo	27983
ibitinga	7750
curitiba	3013
santo andre	2964
belo horizonte	2593
Other values (606)	68344

Length

Max length	40
Median length	9
Mean length	10.10200893
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	68 ?
Unique (%)	0.1%

Sample

1st row	volta redonda
2nd row	sao paulo
3rd row	borda da mata
4th row	franca
5th row	loanda

Common Values

Value	Count	Frequency (%)
sao paulo	27983	24.8%
ibitinga	7750	6.9%
curitiba	3013	2.7%
santo andre	2964	2.6%
belo horizonte	2593	2.3%
sao jose do rio preto	2579	2.3%
rio de janeiro	2442	2.2%
guarulhos	2362	2.1%
ribeirao preto	2269	2.0%
maringa	2220	2.0%
Other values (601)	56472	50.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sao	34728	17.9%
paulo	28233	14.6%
ibitinga	7750	4.0%
rio	5702	2.9%
do	5291	2.7%
preto	5287	2.7%
de	4020	2.1%
jose	3904	2.0%
santo	3081	1.6%
curitiba	3013	1.6%
Other values (640)	92660	47.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

seller_state
Categorical

HIGH CORRELATION

Distinct	23
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.3 MiB

SP	80342
MG	8827
PR	8668
RJ	4818
SC	4075
Other values (18)	5917

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	SP
2nd row	SP
3rd row	MG
4th row	SP
5th row	PR

Common Values

Value	Count	Frequency (%)
SP	80342	71.3%
MG	8827	7.8%
PR	8668	7.7%
RJ	4818	4.3%
SC	4075	3.6%
RS	2199	2.0%
DF	899	0.8%
BA	643	0.6%
GO	520	0.5%
PE	448	0.4%
Other values (13)	1208	1.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sp	80342	71.3%
mg	8827	7.8%
pr	8668	7.7%
rj	4818	4.3%
sc	4075	3.6%
rs	2199	2.0%
df	899	0.8%
ba	643	0.6%
go	520	0.5%
pe	448	0.4%
Other values (13)	1208	1.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

product_category_name_english
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct	72
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.5 MiB

bed_bath_table	11115
health_beauty	9667
sports_leisure	8641
furniture_decor	8334
computers_accessories	7827
Other values (67)	67063

Length

Max length	39
Median length	13
Mean length	12.94820989
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	cool_stuff
2nd row	pet_shop
3rd row	furniture_decor
4th row	perfumery
5th row	garden_tools

Common Values

Value	Count	Frequency (%)
bed_bath_table	11115	9.9%
health_beauty	9667	8.6%
sports_leisure	8641	7.7%
furniture_decor	8334	7.4%
computers_accessories	7827	6.9%
housewares	6964	6.2%
watches_gifts	5991	5.3%
telephony	4545	4.0%
garden_tools	4347	3.9%
auto	4235	3.8%
Other values (62)	40981	36.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
bed_bath_table	11115	9.7%
health_beauty	9667	8.5%
sports_leisure	8641	7.6%
furniture_decor	8334	7.3%
computers_accessories	7827	6.8%
housewares	6964	6.1%
watches_gifts	5991	5.2%
telephony	4545	4.0%
garden_tools	4347	3.8%
auto	4235	3.7%
Other values (63)	42608	37.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

customer_id
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	98665
Distinct (%)	87.6%
Missing	0
Missing (%)	0.0%
Memory size	9.6 MiB

fc3d1daec319d62d49bfb5e1f83123e9	21
bd5d39761aa56689a265d95d8d32b8be	20
be1b70680b9f9694d8c70f41fa3dc92b	20
adb32467ecc74b53576d9d13a5a55891	15
10de381f8a8d23fff822753305f71cae	15
Other values (98660)	112556

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	88863 ?
Unique (%)	78.9%

Sample

1st row	3ce436f183e68e07877b285a838db11a
2nd row	f6dd3ec061db4e3987629fe6b26e5cce
3rd row	6489ae5e4333f3693df5ad4372dab6d3
4th row	d4eb9395c8c0431ee92fce09860c5a06
5th row	58dbd0b2d70206bf40e62cd34e84d795

Common Values

Value	Count	Frequency (%)
fc3d1daec319d62d49bfb5e1f83123e9	21	< 0.1%
bd5d39761aa56689a265d95d8d32b8be	20	< 0.1%
be1b70680b9f9694d8c70f41fa3dc92b	20	< 0.1%
adb32467ecc74b53576d9d13a5a55891	15	< 0.1%
10de381f8a8d23fff822753305f71cae	15	< 0.1%
d5f2b3f597c7ccafbb5cac0bcc3d6024	14	< 0.1%
a7693fba2ff9583c78751f2b66ecab9d	14	< 0.1%
7d321bd4e8ba1caf74c4c1aabd9ae524	13	< 0.1%
3b54b5978e9ace64a63f90d176ffb158	12	< 0.1%
91f92cfee46b79581b05aa974dd57ce5	12	< 0.1%
Other values (98655)	112491	99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
fc3d1daec319d62d49bfb5e1f83123e9	21	< 0.1%
be1b70680b9f9694d8c70f41fa3dc92b	20	< 0.1%
bd5d39761aa56689a265d95d8d32b8be	20	< 0.1%
adb32467ecc74b53576d9d13a5a55891	15	< 0.1%
10de381f8a8d23fff822753305f71cae	15	< 0.1%
d5f2b3f597c7ccafbb5cac0bcc3d6024	14	< 0.1%
a7693fba2ff9583c78751f2b66ecab9d	14	< 0.1%
7d321bd4e8ba1caf74c4c1aabd9ae524	13	< 0.1%
0d93f21f3e8543a9d0d8ece01561f5b2	12	< 0.1%
9eb3d566e87289dcb0acf28e1407c839	12	< 0.1%
Other values (98655)	112491	99.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

order_status
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.1 MiB

delivered	110194
shipped	1185
canceled	542
invoiced	359
processing	357
Other values (2)	10

Length

Max length	11
Median length	9
Mean length	8.974229229
Min length	7

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	delivered
2nd row	delivered
3rd row	delivered
4th row	delivered
5th row	delivered

Common Values

Value	Count	Frequency (%)
delivered	110194	97.8%
shipped	1185	1.1%
canceled	542	0.5%
invoiced	359	0.3%
processing	357	0.3%
unavailable	7	< 0.1%
approved	3	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
delivered	110194	97.8%
shipped	1185	1.1%
canceled	542	0.5%
invoiced	359	0.3%
processing	357	0.3%
unavailable	7	< 0.1%
approved	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

order_date
Date

Distinct	98111
Distinct (%)	87.1%
Missing	0
Missing (%)	0.0%
Memory size	880.2 KiB

Minimum	2016-09-04 21:15:19
Maximum	2018-09-03 09:06:57

Histogram

Histogram with fixed size bins (bins=50)

order_delivery_date
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	96049
Distinct (%)	85.3%
Missing	0
Missing (%)	0.0%
Memory size	8.2 MiB

2017-07-31 18:03:02	21
2018-08-13 00:00:00	20
2017-12-01 00:00:00	20
2018-03-05 15:22:27	20
2017-09-02 12:13:03	20
Other values (96044)	112546

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	85406 ?
Unique (%)	75.8%

Sample

1st row	2017-09-20 23:43:48
2nd row	2017-05-12 16:04:24
3rd row	2018-01-22 13:19:16
4th row	2018-08-14 13:32:39
5th row	2017-03-01 16:42:31

Common Values

Value	Count	Frequency (%)
2017-07-31 18:03:02	21	< 0.1%
2018-08-13 00:00:00	20	< 0.1%
2017-12-01 00:00:00	20	< 0.1%
2018-03-05 15:22:27	20	< 0.1%
2017-09-02 12:13:03	20	< 0.1%
2018-08-10 00:00:00	18	< 0.1%
2018-04-12 00:00:00	17	< 0.1%
2018-03-13 00:00:00	17	< 0.1%
2017-12-05 00:00:00	17	< 0.1%
2018-02-06 00:00:00	17	< 0.1%
Other values (96039)	112460	99.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
00:00:00	2454	1.1%
2018-05-14	524	0.2%
2018-08-13	521	0.2%
2018-05-21	508	0.2%
2018-08-27	501	0.2%
2018-05-18	494	0.2%
2018-04-11	482	0.2%
2017-12-11	480	0.2%
2018-05-03	476	0.2%
2017-06-19	473	0.2%
Other values (41745)	218381	96.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

order_estimated_delivery_date
Categorical

HIGH CARDINALITY

Distinct	449
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	8.2 MiB

2017-12-20 00:00:00	604
2018-05-29 00:00:00	598
2018-03-12 00:00:00	592
2018-03-13 00:00:00	584
2018-07-05 00:00:00	571
Other values (444)	109698

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	18 ?
Unique (%)	< 0.1%

Sample

1st row	2017-09-29 00:00:00
2nd row	2017-05-15 00:00:00
3rd row	2018-02-05 00:00:00
4th row	2018-08-20 00:00:00
5th row	2017-03-17 00:00:00

Common Values

Value	Count	Frequency (%)
2017-12-20 00:00:00	604	0.5%
2018-05-29 00:00:00	598	0.5%
2018-03-12 00:00:00	592	0.5%
2018-03-13 00:00:00	584	0.5%
2018-07-05 00:00:00	571	0.5%
2018-05-28 00:00:00	563	0.5%
2017-12-19 00:00:00	563	0.5%
2018-02-14 00:00:00	562	0.5%
2017-12-18 00:00:00	562	0.5%
2018-05-30 00:00:00	559	0.5%
Other values (439)	106889	94.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
00:00:00	112647	50.0%
2017-12-20	604	0.3%
2018-05-29	598	0.3%
2018-03-12	592	0.3%
2018-03-13	584	0.3%
2018-07-05	571	0.3%
2018-05-28	563	0.2%
2017-12-19	563	0.2%
2018-02-14	562	0.2%
2017-12-18	562	0.2%
Other values (440)	107448	47.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

review_score
Real number (ℝ_≥0)

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.016149269

Minimum	1
Maximum	5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	880.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3.5
median	5
Q3	5
95-th percentile	5
Maximum	5
Range	4
Interquartile range (IQR)	1.5

Descriptive statistics

Standard deviation	1.398448033
Coefficient of variation (CV)	0.3482061895
Kurtosis	0.1239715653
Mean	4.016149269
Median Absolute Deviation (MAD)	0
Skewness	-1.246036083
Sum	452407.1667
Variance	1.955656902
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
5	63180	56.1%
4	21229	18.8%
1	14626	13.0%
3	9502	8.4%
2	3941	3.5%
4.5	69	0.1%
2.5	48	< 0.1%
3.5	32	< 0.1%
1.5	18	< 0.1%
3.333333333	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	14626	13.0%
1.5	18	< 0.1%
2	3941	3.5%
2.5	48	< 0.1%
3	9502	8.4%
3.333333333	1	< 0.1%
3.5	32	< 0.1%
4	21229	18.8%
4.333333333	1	< 0.1%
4.5	69	0.1%

Value	Count	Frequency (%)
5	63180	56.1%
4.5	69	0.1%
4.333333333	1	< 0.1%
4	21229	18.8%
3.5	32	< 0.1%
3.333333333	1	< 0.1%
3	9502	8.4%
2.5	48	< 0.1%
2	3941	3.5%
1.5	18	< 0.1%

total_payment
Real number (ℝ_≥0)

Distinct	28281
Distinct (%)	25.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	414.6471918

Minimum	22.05
Maximum	31427.38
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	880.2 KiB

Quantile statistics

Minimum	22.05
5-th percentile	76.986
Q1	151.04
median	263.21
Q3	449.4
95-th percentile	1222.4
Maximum	31427.38
Range	31405.33
Interquartile range (IQR)	298.36

Descriptive statistics

Standard deviation	627.5527635
Coefficient of variation (CV)	1.513461989
Kurtosis	489.284683
Mean	414.6471918
Median Absolute Deviation (MAD)	131.01
Skewness	13.87773494
Sum	46708762.21
Variance	393822.471
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
178.41	255	0.2%
80.5	166	0.1%
168.68	161	0.1%
268.96	131	0.1%
130.59	123	0.1%
149.5	117	0.1%
247.89	117	0.1%
356.82	117	0.1%
229.77	106	0.1%
155.25	106	0.1%
Other values (28271)	111248	98.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
22.05	1	< 0.1%
23.16	1	< 0.1%
25.05	1	< 0.1%
26.59	1	< 0.1%
26.73	1	< 0.1%
26.75	2	< 0.1%
28.11	1	< 0.1%
28.24	1	< 0.1%
28.5	1	< 0.1%
29.65	2	< 0.1%

Value	Count	Frequency (%)
31427.38	8	< 0.1%
16732.22	4	< 0.1%
15937.41	1	< 0.1%
15921.08	1	< 0.1%
15471.32	1	< 0.1%
13987.54	6	< 0.1%
11385.78	1	< 0.1%
11061.71	2	< 0.1%
10957.98	1	< 0.1%
10768.09	1	< 0.1%

payment_type
Categorical

HIGH CARDINALITY

Distinct	74
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.2 MiB

credit_card	83616
boleto	22867
debit_card	1688
voucher	1192
credit_card,voucher	1112
Other values (69)	2172

Length

Max length	231
Median length	11
Mean length	10.27495628
Min length	6

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	24 ?
Unique (%)	< 0.1%

Sample

1st row	credit_card
2nd row	credit_card
3rd row	credit_card
4th row	credit_card
5th row	credit_card

Common Values

Value	Count	Frequency (%)
credit_card	83616	74.2%
boleto	22867	20.3%
debit_card	1688	1.5%
voucher	1192	1.1%
credit_card,voucher	1112	1.0%
voucher,credit_card	954	0.8%
credit_card,credit_card	331	0.3%
voucher,voucher	243	0.2%
voucher,voucher,credit_card	100	0.1%
voucher,voucher,voucher	95	0.1%
Other values (64)	449	0.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
credit_card	83616	74.2%
boleto	22867	20.3%
debit_card	1688	1.5%
voucher	1192	1.1%
credit_card,voucher	1112	1.0%
voucher,credit_card	954	0.8%
credit_card,credit_card	331	0.3%
voucher,voucher	243	0.2%
voucher,voucher,credit_card	100	0.1%
voucher,voucher,voucher	95	0.1%
Other values (64)	449	0.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

customer_unique_id
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	95419
Distinct (%)	84.7%
Missing	0
Missing (%)	0.0%
Memory size	9.6 MiB

c8460e4251689ba205045f3ea17884a1	24
4546caea018ad8c692964e3382debd19	21
698e1cf81d01a3d389d96145f7fa6df8	20
c402f431464c72e27330a67f7b94d4fb	20
0f5ac8d5c31de21d2f25e24be15bbffb	18
Other values (95414)	112544

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	83551 ?
Unique (%)	74.2%

Sample

1st row	871766c5855e863f6eccc05f988b23cb
2nd row	eb28e67c4c0b83846050ddfb8a35d051
3rd row	3818d81c6709e39d06b2738a8d3a2474
4th row	af861d436cfc08b2c2ddefd0ba074622
5th row	64b576fb70d441e8f1b2d7d446e483c5

Common Values

Value	Count	Frequency (%)
c8460e4251689ba205045f3ea17884a1	24	< 0.1%
4546caea018ad8c692964e3382debd19	21	< 0.1%
698e1cf81d01a3d389d96145f7fa6df8	20	< 0.1%
c402f431464c72e27330a67f7b94d4fb	20	< 0.1%
0f5ac8d5c31de21d2f25e24be15bbffb	18	< 0.1%
8d50f5eadf50201ccdcedfb9e2ac8455	16	< 0.1%
eae0a83d752b1dd32697e0e7b4221656	15	< 0.1%
11f97da02237a49c8e783dfda6f50e8e	15	< 0.1%
31e412b9fb766b6794724ed17a41dfa6	14	< 0.1%
f7ea4eef770a388bd5b225acfc546604	14	< 0.1%
Other values (95409)	112470	99.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
c8460e4251689ba205045f3ea17884a1	24	< 0.1%
4546caea018ad8c692964e3382debd19	21	< 0.1%
698e1cf81d01a3d389d96145f7fa6df8	20	< 0.1%
c402f431464c72e27330a67f7b94d4fb	20	< 0.1%
0f5ac8d5c31de21d2f25e24be15bbffb	18	< 0.1%
8d50f5eadf50201ccdcedfb9e2ac8455	16	< 0.1%
eae0a83d752b1dd32697e0e7b4221656	15	< 0.1%
11f97da02237a49c8e783dfda6f50e8e	15	< 0.1%
3e43e6105506432c953e165fb2acf44c	14	< 0.1%
31e412b9fb766b6794724ed17a41dfa6	14	< 0.1%
Other values (95409)	112470	99.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

customer_zip_code
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	14976
Distinct (%)	13.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	35119.85556

Minimum	1003
Maximum	99990
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	880.2 KiB

Quantile statistics

Minimum	1003
5-th percentile	3308
Q1	11310
median	24340
Q3	59030
95-th percentile	90598
Maximum	99990
Range	98987
Interquartile range (IQR)	47720

Descriptive statistics

Standard deviation	29866.33077
Coefficient of variation (CV)	0.8504115491
Kurtosis	-0.7928674712
Mean	35119.85556
Median Absolute Deviation (MAD)	16389
Skewness	0.7801231393
Sum	3956146369
Variance	891997713.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22790	154	0.1%
22793	151	0.1%
24220	145	0.1%
24230	134	0.1%
22775	123	0.1%
29101	113	0.1%
35162	111	0.1%
11740	106	0.1%
13212	104	0.1%
22631	104	0.1%
Other values (14966)	111402	98.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1003	1	< 0.1%
1004	2	< 0.1%
1005	6	< 0.1%
1006	2	< 0.1%
1007	4	< 0.1%
1008	4	< 0.1%
1009	8	< 0.1%
1011	6	< 0.1%
1012	2	< 0.1%
1013	3	< 0.1%

Value	Count	Frequency (%)
99990	1	< 0.1%
99980	3	< 0.1%
99970	1	< 0.1%
99965	2	< 0.1%
99960	1	< 0.1%
99955	3	< 0.1%
99950	9	< 0.1%
99940	2	< 0.1%
99930	5	< 0.1%
99925	1	< 0.1%

customer_city
Categorical

HIGH CARDINALITY

Distinct	4110
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Memory size	7.2 MiB

sao paulo	17808
rio de janeiro	7837
belo horizonte	3144
brasilia	2392
curitiba	1751
Other values (4105)	79715

Length

Max length	32
Median length	9
Mean length	10.33830462
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1057 ?
Unique (%)	0.9%

Sample

1st row	campos dos goytacazes
2nd row	santa fe do sul
3rd row	para de minas
4th row	atibaia
5th row	varzea paulista

Common Values

Value	Count	Frequency (%)
sao paulo	17808	15.8%
rio de janeiro	7837	7.0%
belo horizonte	3144	2.8%
brasilia	2392	2.1%
curitiba	1751	1.6%
campinas	1654	1.5%
porto alegre	1612	1.4%
salvador	1412	1.3%
guarulhos	1329	1.2%
sao bernardo do campo	1060	0.9%
Other values (4100)	72648	64.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sao	23985	12.1%
paulo	17887	9.1%
de	10972	5.6%
rio	9436	4.8%
janeiro	7837	4.0%
do	4868	2.5%
belo	3214	1.6%
horizonte	3172	1.6%
brasilia	2402	1.2%
porto	1915	1.0%
Other values (3280)	111800	56.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

customer_state
Categorical

HIGH CORRELATION

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.3 MiB

SP	47446
RJ	14579
MG	13129
RS	6235
PR	5740
Other values (22)	25518

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RJ
2nd row	SP
3rd row	MG
4th row	SP
5th row	SP

Common Values

Value	Count	Frequency (%)
SP	47446	42.1%
RJ	14579	12.9%
MG	13129	11.7%
RS	6235	5.5%
PR	5740	5.1%
SC	4176	3.7%
BA	3799	3.4%
DF	2406	2.1%
GO	2333	2.1%
ES	2256	2.0%
Other values (17)	10548	9.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sp	47446	42.1%
rj	14579	12.9%
mg	13129	11.7%
rs	6235	5.5%
pr	5740	5.1%
sc	4176	3.7%
ba	3799	3.4%
df	2406	2.1%
go	2333	2.1%
es	2256	2.0%
Other values (17)	10548	9.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

customer_age
Real number (ℝ_≥0)

Distinct	72
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	49.5508358

Minimum	14
Maximum	85
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	880.2 KiB

Quantile statistics

Minimum	14
5-th percentile	17
Q1	32
median	50
Q3	68
95-th percentile	82
Maximum	85
Range	71
Interquartile range (IQR)	36

Descriptive statistics

Standard deviation	20.81476474
Coefficient of variation (CV)	0.4200688929
Kurtosis	-1.201018794
Mean	49.5508358
Median Absolute Deviation (MAD)	18
Skewness	-0.001716514946
Sum	5581753
Variance	433.254431
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
32	1659	1.5%
14	1654	1.5%
50	1643	1.5%
29	1634	1.5%
83	1634	1.5%
71	1625	1.4%
55	1620	1.4%
57	1615	1.4%
67	1613	1.4%
36	1613	1.4%
Other values (62)	96337	85.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
14	1654	1.5%
15	1575	1.4%
16	1544	1.4%
17	1565	1.4%
18	1531	1.4%
19	1556	1.4%
20	1553	1.4%
21	1503	1.3%
22	1592	1.4%
23	1570	1.4%

Value	Count	Frequency (%)
85	1597	1.4%
84	1587	1.4%
83	1634	1.5%
82	1611	1.4%
81	1574	1.4%
80	1559	1.4%
79	1563	1.4%
78	1502	1.3%
77	1592	1.4%
76	1577	1.4%

customer_income
Real number (ℝ_≥0)

Distinct	35159
Distinct (%)	31.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20924.35273

Minimum	2000
Maximum	40000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	880.2 KiB

Quantile statistics

Minimum	2000
5-th percentile	3860
Q1	11476
median	20867
Q3	30441.5
95-th percentile	38055.7
Maximum	40000
Range	38000
Interquartile range (IQR)	18965.5

Descriptive statistics

Standard deviation	10959.11792
Coefficient of variation (CV)	0.5237494352
Kurtosis	-1.198209257
Mean	20924.35273
Median Absolute Deviation (MAD)	9474
Skewness	0.006106550577
Sum	2357065562
Variance	120102265.7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7703	21	< 0.1%
23733	21	< 0.1%
11516	20	< 0.1%
2014	18	< 0.1%
5610	18	< 0.1%
17115	18	< 0.1%
15098	17	< 0.1%
24651	16	< 0.1%
39268	16	< 0.1%
27619	16	< 0.1%
Other values (35149)	112466	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2000	2	< 0.1%
2001	1	< 0.1%
2002	3	< 0.1%
2003	3	< 0.1%
2004	3	< 0.1%
2006	2	< 0.1%
2007	1	< 0.1%
2008	2	< 0.1%
2009	8	< 0.1%
2010	3	< 0.1%

Value	Count	Frequency (%)
40000	5	< 0.1%
39999	2	< 0.1%
39998	1	< 0.1%
39997	4	< 0.1%
39996	7	< 0.1%
39995	1	< 0.1%
39994	6	< 0.1%
39992	1	< 0.1%
39991	2	< 0.1%
39990	3	< 0.1%

customer_marital_status
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

0	56395
1	56252

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	1
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	56395	50.1%
1	56252	49.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	56395	50.1%
1	56252	49.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

order_year
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.6 MiB

2018	61416
2017	50864
2016	367

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2017
2nd row	2017
3rd row	2018
4th row	2018
5th row	2017

Common Values

Value	Count	Frequency (%)
2018	61416	54.5%
2017	50864	45.2%
2016	367	0.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
2018	61416	54.5%
2017	50864	45.2%
2016	367	0.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

order_month
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.02675615

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	880.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	8
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.232548014
Coefficient of variation (CV)	0.5363661534
Kurtosis	-0.9806750194
Mean	6.02675615
Median Absolute Deviation (MAD)	2
Skewness	0.2084695862
Sum	678896
Variance	10.44936666
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
8	12158	10.8%
5	12061	10.7%
7	11611	10.3%
3	11217	10.0%
6	10661	9.5%
4	10659	9.5%
2	9623	8.5%
1	9163	8.1%
11	8665	7.7%
12	6309	5.6%
Other values (2)	10520	9.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	9163	8.1%
2	9623	8.5%
3	11217	10.0%
4	10659	9.5%
5	12061	10.7%
6	10661	9.5%
7	11611	10.3%
8	12158	10.8%
9	4835	4.3%
10	5685	5.0%

Value	Count	Frequency (%)
12	6309	5.6%
11	8665	7.7%
10	5685	5.0%
9	4835	4.3%
8	12158	10.8%
7	11611	10.3%
6	10661	9.5%
5	12061	10.7%
4	10659	9.5%
3	11217	10.0%

order_weekday
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

Monday	18393
Tuesday	18237
Wednesday	17600
Thursday	16794
Friday	16039
Other values (2)	25584

Length

Max length	9
Median length	7
Mean length	7.144824097
Min length	6

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Wednesday
2nd row	Wednesday
3rd row	Sunday
4th row	Wednesday
5th row	Saturday

Common Values

Value	Count	Frequency (%)
Monday	18393	16.3%
Tuesday	18237	16.2%
Wednesday	17600	15.6%
Thursday	16794	14.9%
Friday	16039	14.2%
Sunday	13416	11.9%
Saturday	12168	10.8%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
monday	18393	16.3%
tuesday	18237	16.2%
wednesday	17600	15.6%
thursday	16794	14.9%
friday	16039	14.2%
sunday	13416	11.9%
saturday	12168	10.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	order_id	order_item_id	product_id	seller_id	seller_zip_code	seller_city	seller_state	product_category_name_english	customer_id	order_status	order_date	order_delivery_date	order_estimated_delivery_date	review_score	total_payment	payment_type	customer_unique_id	customer_zip_code	customer_city	customer_state	customer_age	customer_income	customer_marital_status	order_year	order_month	order_weekday
0	0	00010242fe8c5a6d1ba2dd792cb16214	1	4244733e06e7ecb4970a6e2683c13e61	48436dade18ac8b2bce089ec2a041202	27277	volta redonda	SP	cool_stuff	3ce436f183e68e07877b285a838db11a	delivered	2017-09-13 08:59:02	2017-09-20 23:43:48	2017-09-29 00:00:00	5.0	166.04	credit_card	871766c5855e863f6eccc05f988b23cb	28013	campos dos goytacazes	RJ	77	7208	0	2017	9	Wednesday
1	1	00018f77f2f0320c557190d7a144bdd3	1	e5f2d52b802189ee658865ca93d83a8f	dd7ddc04e1b6c2c614352b383efe2d36	3471	sao paulo	SP	pet_shop	f6dd3ec061db4e3987629fe6b26e5cce	delivered	2017-04-26 10:53:06	2017-05-12 16:04:24	2017-05-15 00:00:00	4.0	597.61	credit_card	eb28e67c4c0b83846050ddfb8a35d051	15775	santa fe do sul	SP	15	6142	1	2017	4	Wednesday
2	2	000229ec398224ef6ca0657da4fc703e	1	c777355d18b72b67abbeef9df44fd0fd	5b51032eddd242adc84c38acab88f23d	37564	borda da mata	MG	furniture_decor	6489ae5e4333f3693df5ad4372dab6d3	delivered	2018-01-14 14:33:31	2018-01-22 13:19:16	2018-02-05 00:00:00	5.0	498.80	credit_card	3818d81c6709e39d06b2738a8d3a2474	35661	para de minas	MG	64	24244	1	2018	1	Sunday
3	3	00024acbcdf0a6daa1e931b038114c75	1	7634da152a4610f1595efa32f14722fc	9d7a1d34a5052409006425275ba1c2b4	14403	franca	SP	perfumery	d4eb9395c8c0431ee92fce09860c5a06	delivered	2018-08-08 10:00:35	2018-08-14 13:32:39	2018-08-20 00:00:00	4.0	59.29	credit_card	af861d436cfc08b2c2ddefd0ba074622	12952	atibaia	SP	56	23541	0	2018	8	Wednesday
4	4	00042b26cf59d7ce69dfabb4e55b4fd9	1	ac6c3623068f30de03045865e4e10089	df560393f3a51e74553ab94004ba5c87	87900	loanda	PR	garden_tools	58dbd0b2d70206bf40e62cd34e84d795	delivered	2017-02-04 13:57:51	2017-03-01 16:42:31	2017-03-17 00:00:00	5.0	501.49	credit_card	64b576fb70d441e8f1b2d7d446e483c5	13226	varzea paulista	SP	59	29817	0	2017	2	Saturday
5	5	00048cc3ae777c65dbb7d2a0634bc1ea	1	ef92defde845ab8450f9d70c526ef70f	6426d21aca402a131fc0a5d0960a3c90	14091	ribeirao preto	SP	housewares	816cbea969fe5b689b39cfc97a506742	delivered	2017-05-15 21:42:34	2017-05-22 13:44:35	2017-06-06 00:00:00	4.0	79.56	boleto	85c835d128beae5b4ce8602c491bf385	38017	uberaba	MG	14	37081	0	2017	5	Monday
6	6	00054e8431b9d7675808bcb819fb4a32	1	8d4f2bb7e93e6710a28f34fa83ee7d28	7040e82f899a04d1b434b795a43b4617	1026	sao paulo	SP	telephony	32e2e6ab09e778d99bf2e0ecd4898718	delivered	2017-12-10 11:53:48	2017-12-18 22:03:38	2018-01-04 00:00:00	4.0	73.03	credit_card	635d9ac1680f03288e72ada3a1035803	16700	guararapes	SP	39	25237	0	2017	12	Sunday
7	7	000576fe39319847cbb9d288c5617fa6	1	557d850972a7d6f792fd18ae1400d9b6	5996cddab893a4652a15592fb58ab8db	19010	presidente prudente	SP	garden_tools	9ed5e522dd9dd85b4af4a077526d8117	delivered	2018-07-04 12:08:27	2018-07-09 14:04:07	2018-07-25 00:00:00	5.0	2025.73	credit_card	fda4476abb6307ab3c415b7e6d026526	11702	praia grande	SP	64	29705	0	2018	7	Wednesday
8	8	0005a1a1728c9d785b8e2b08b904576c	1	310ae3c140ff94b03219ad0adc3c778f	a416b6a846a11724393025641d4edd5e	3702	sao paulo	SP	health_beauty	16150771dfd4776261284213b89c304e	delivered	2018-03-19 18:40:33	2018-03-29 18:17:31	2018-03-29 00:00:00	1.0	362.48	credit_card	639d23421f5517f69d0c3d6e6564cf0e	11075	santos	SP	22	29901	0	2018	3	Monday
9	9	0005f50442cb953dcd1d21e1fb923495	1	4535b0e1091c278dfd193e5a1d63b39f	ba143b05f0110f0dc71ad71b4466ce92	2274	sao paulo	SP	books_technical	351d3cb2cee3c7fd0af6616c82df21d3	delivered	2018-07-02 13:59:39	2018-07-04 17:28:31	2018-07-23 00:00:00	4.0	150.40	credit_card	0782c41380992a5a533489063df0eef6	6636	jandira	SP	80	32094	0	2018	7	Monday

Last rows

	df_index	order_id	order_item_id	product_id	seller_id	seller_zip_code	seller_city	seller_state	product_category_name_english	customer_id	order_status	order_date	order_delivery_date	order_estimated_delivery_date	review_score	total_payment	payment_type	customer_unique_id	customer_zip_code	customer_city	customer_state	customer_age	customer_income	customer_marital_status	order_year	order_month	order_weekday
112637	112640	fffb9224b6fc7c43ebb0904318b10b5f	1	43423cdffde7fda63d0414ed38c11a73	b1fc4f64df5a0e8b6913ab38803c57a9	24440	sao goncalo	RJ	watches_gifts	4d3abb73ceb86353aeadbe698aa9d5cb	delivered	2017-10-27 16:51:00	2017-11-17 19:41:42	2017-11-27 00:00:00	4.0	820.55	boleto	f736308cd9952b33b90b9fe94da9c8f5	56912	serra talhada	PE	14	7942	1	2017	10	Friday
112638	112641	fffb9224b6fc7c43ebb0904318b10b5f	2	43423cdffde7fda63d0414ed38c11a73	b1fc4f64df5a0e8b6913ab38803c57a9	24440	sao goncalo	RJ	watches_gifts	4d3abb73ceb86353aeadbe698aa9d5cb	delivered	2017-10-27 16:51:00	2017-11-17 19:41:42	2017-11-27 00:00:00	4.0	820.55	boleto	f736308cd9952b33b90b9fe94da9c8f5	56912	serra talhada	PE	14	7942	1	2017	10	Friday
112639	112642	fffb9224b6fc7c43ebb0904318b10b5f	3	43423cdffde7fda63d0414ed38c11a73	b1fc4f64df5a0e8b6913ab38803c57a9	24440	sao goncalo	RJ	watches_gifts	4d3abb73ceb86353aeadbe698aa9d5cb	delivered	2017-10-27 16:51:00	2017-11-17 19:41:42	2017-11-27 00:00:00	4.0	820.55	boleto	f736308cd9952b33b90b9fe94da9c8f5	56912	serra talhada	PE	14	7942	1	2017	10	Friday
112640	112643	fffb9224b6fc7c43ebb0904318b10b5f	4	43423cdffde7fda63d0414ed38c11a73	b1fc4f64df5a0e8b6913ab38803c57a9	24440	sao goncalo	RJ	watches_gifts	4d3abb73ceb86353aeadbe698aa9d5cb	delivered	2017-10-27 16:51:00	2017-11-17 19:41:42	2017-11-27 00:00:00	4.0	820.55	boleto	f736308cd9952b33b90b9fe94da9c8f5	56912	serra talhada	PE	14	7942	1	2017	10	Friday
112641	112644	fffbee3b5462987e66fb49b1c5411df2	1	6f0169f259bb0ff432bfff7d829b9946	213b25e6f54661939f11710a6fddb871	13321	salto	SP	home_construction	11a0e041ea6e7e21856d2689b64e7f3a	delivered	2018-06-19 09:27:48	2018-07-05 17:51:08	2018-07-23 00:00:00	5.0	321.72	credit_card	ecc3d4eb9b17d2f0865d21f2abecc51c	39401	montes claros	MG	21	18335	1	2018	6	Tuesday
112642	112645	fffc94f6ce00a00581880bf54a75a037	1	4aa6014eceb682077f9dc4bffebc05b0	b8bc237ba3788b23da09c0f1f3a3288c	88303	itajai	SC	housewares	b51593916b4b8e0d6f66f2ae24f2673d	delivered	2018-04-23 13:57:06	2018-05-10 22:56:40	2018-05-18 00:00:00	5.0	789.82	boleto	0c9aeda10a71f369396d0c04dce13a64	65077	sao luis	MA	35	22497	0	2018	4	Monday
112643	112646	fffcd46ef2263f404302a634eb57f7eb	1	32e07fd915822b0765e448c4dd74c828	f3c38ab652836d21de61fb8314b69182	1206	sao paulo	SP	computers_accessories	84c5d4fbaf120aae381fad077416eaa0	delivered	2018-07-14 10:26:46	2018-07-23 20:31:55	2018-08-01 00:00:00	5.0	889.02	boleto	0da9fe112eae0c74d3ba1fe16de0988b	81690	curitiba	PR	36	27170	1	2018	7	Saturday
112644	112647	fffce4705a9662cd70adb13d4a31832d	1	72a30483855e2eafc67aee5dc2560482	c3cfdc648177fdbbbb35635a37472c53	80610	curitiba	PR	sports_leisure	29309aa813182aaddc9b259e31b870e6	delivered	2017-10-23 17:07:56	2017-10-28 12:22:22	2017-11-10 00:00:00	5.0	268.76	credit_card	cd79b407828f02fdbba457111c38e4c4	4039	sao paulo	SP	61	37357	1	2017	10	Monday
112645	112648	fffe18544ffabc95dfada21779c9644f	1	9c422a519119dcad7575db5af1ba540e	2b3e4a2a3ea8e01938cabda2a3e5cc79	4733	sao paulo	SP	computers_accessories	b5e6afd5a41800fdf401e0272ca74655	delivered	2017-08-14 23:02:59	2017-08-16 21:59:40	2017-08-25 00:00:00	5.0	148.83	credit_card	eb803377c9315b564bdedad672039306	13289	vinhedo	SP	67	3786	0	2017	8	Monday
112646	112649	fffe41c64501cc87c801fd61db3f6244	1	350688d9dc1e75ff97be326363655e01	f7ccf836d21b2fb1de37564105216cc1	14940	ibitinga	SP	bed_bath_table	96d649da0cc4ff33bb408b199d4c7dcf	delivered	2018-06-09 17:00:18	2018-06-14 17:56:26	2018-06-28 00:00:00	5.0	128.32	credit_card	cd76a00d8e3ca5e6ab9ed9ecb6667ac4	18605	botucatu	SP	58	39665	1	2018	6	Saturday

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category